#region Using directives
using System;
using System.Data;
using WP.Commons;
#endregion

namespace WP.MF.DataEntity
{

    /*
     * Created by Web Smart Create Code Tool
     * At 8/2/2006
     */

    //=========MCurrency  ============================
    [System.ComponentModel.DesignerCategory("Code")]
    public class MCurrencyDEL : DataSet, IDataEntity
    {
        //=========mCurrency ============================
        public const string TABLENAME_MCURRENCY = "mCurrency";
        public const string RECID = "RecId";
        public const string CURNO = "CurNo";
        public const string CURCODE = "CurCode";
        public const string CURDESC = "CurDesc";
        public const string CURRATESELLPRODUCT = "CurRateSellProduct";
        public const string ReportCurRate = "ReportCurRate";
        public const string CURRATEPURCHPRODUCT = "CurRatePurchProduct";
        public const string ARACCTNO = "arAcctNo";
        public const string ARPROFITNO = "arProfitNo";
        public const string ARBRNNO = "arBrnNo";
        public const string AREXCHACCTNO = "arExchAcctNo";
        public const string AREXCHPROFITNO = "arExchProfitNo";
        public const string AREXCHBRNNO = "arExchBrnNo";
        public const string APACCTNO = "apAcctNo";
        public const string APPROFITNO = "apProfitNo";
        public const string APBRNNO = "apBrnNo";
        public const string APEXCHACCTNO = "apExchAcctNo";
        public const string APEXCHPROFITNO = "apExchProfitNo";
        public const string APEXCHBRNNO = "apExchBrnNo";
        public const string BANKACCTNO = "BankAcctNo";
        public const string BANKPROFITNO = "BankProfitNo";
        public const string BANKBRNNO = "BankBrnNo";
        public const string BANKEXCHACCTNO = "BankExchAcctNo";
        public const string BANKEXCHPROFITNO = "BankExchProfitNo";
        public const string BANKEXCHBRNNO = "BankExchBrnNo";
        public const string ARDISCACCTNO = "arDiscAcctNo";
        public const string ARDISCPROFITNO = "arDiscProfitNo";
        public const string ARDISCBRNNO = "arDiscBrnNo";
        public const string INTERESTACCTNO = "InterestAcctNo";
        public const string INTERESTPROFITNO = "InterestProfitNo";
        public const string INTERESTBRNNO = "InterestBrnNo";
        public const string APDISCACCTNO = "apDiscAcctNo";
        public const string APDISCPROFITNO = "apDiscProfitNo";
        public const string APDISCBRNNO = "apDiscBrnNo";
        public const string LASTCHQNO = "LastChqNo";
        public const string ACCRUACCTNO = "AccruAcctNo";
        public const string ACCRUPROFITNO = "AccruProfitNo";
        public const string APBANKACCTNO = "apBankAcctNo";
        public const string APBANKPROFITNO = "apBankProfitNo";
        public const string APBANKBRNNO = "apBankBrnNo";
        public const string LASTRATECHGDATE = "LastRateChgDate";
        public const string SETTDISCACCTNO = "SettDiscAcctNo";
        public const string SETTDISCPROFITNO = "SettDiscProfitNo";
        public const string SETTDISCBRNNO = "SettDiscBrnNo";
        public const string ARGSTACCTNO = "arGstAcctNo";
        public const string ARGSTPROFITNO = "arGstProfitNo";
        public const string ARGSTBRNNO = "arGstBrnNo";
        public const string APGSTACCTNO = "apGstAcctNo";
        public const string APGSTPROFITNO = "apGstProfitNo";
        public const string APGSTBRNNO = "apGstBrnNo";
        public const string REBATECRACCTNO = "RebateCrAcctNo";
        public const string REBATECRPROFITNO = "RebateCrProfitNo";
        public const string REBATEDRACCTNO = "RebateDrAcctNo";
        public const string REBATEDRPROFITNO = "RebateDrProfitNo";
        public const string DEPOSITACCTNO = "DepositAcctNo";
        public const string DEPOSITPROFITNO = "DepositProfitNo";
        public const string DEPOSITBRNNO = "DepositBrnNo";
        public const string OVERSHORTACCTNO = "OverShortAcctNo";
        public const string OVERSHORTPROFITNO = "OverShortProfitNo";
        public const string OVERSHORTBRNNO = "OverShortBrnNo";
        public const string FRTREDTACCTNO = "FrtRedtAcctNo";
        public const string FRTREDTPROFITNO = "FrtRedtProfitNo";
        public const string LASTCHQNO1 = "LastChqNo1";
        public const string BRANCHCLEARACCTNO = "BranchClearAcctNO";
        public const string BRANCHCLEARPROFITNO = "BranchClearProfitNO";
        public const string BRANCHCLEARBRNNO = "BranchClearBrnNO";
        public const string INTERCOMPFUNDTRFACCTNO = "InterCompFundTrfAcctNo";
        public const string INTERCOMPFUNDTRFPROFITNO = "InterCompFundTrfProfitNo";
        public const string INTERCOMPFUNDTRFBRANCHNO = "InterCompFundTrfBranchNo";
        public const string INVTRFACCTNO = "InvTrfAcctNo";
        public const string INVTRFPROFITNO = "InvTrfProfitNo";

        public const string FREIGHTAPACCTNO = "FreightAPAcctNo";
        public const string FREIGHTAPPROFITNO = "FreightAPProfitNo";
        public const string FREIGHTAPBRNNO = "FreightAPBrnNo";
        public const string MILLAPACCTNO = "MillAPAcctNo";
        public const string MILLAPPROFITNO = "MillAPProfitNo";
        public const string MILLAPBRNNO = "MillAPBrnNo";
        public const string MISCAPACCTNO = "MiscAPAcctNo";
        public const string MISCAPPROFITNO = "MiscAPProfitNo";
        public const string MISCAPBRNNO = "MiscAPBrnNo";
        public const string FREIGHTINACCRUACCTNO = "FreightInAccruAcctNo";
        public const string FREIGHTINACCRUPROFITNO = "FreightInAccruProfitNo";
        public const string FREIGHTINACCRUBRNNO = "FreightInAccruBrnNo";
        public const string FREIGHTOUTACCRUACCTNO = "FreightOutAccruAcctNo";
        public const string FREIGHTOUTACCRUPROFITNO = "FreightOutAccruProfitNo";
        public const string FREIGHTOUTACCRUBRNNO = "FreightOutAccruBrnNo";
        public const string HANDINGACCRUACCTNO = "HandingAccruAcctNo";
        public const string HANDINGACCRUPROFITNO = "HandingAccruProfitNo";
        public const string HANDINGACCRUBRNNO = "HandingAccruBrnNo";
        public const string REBATEACCRUACCTNO = "RebateAccruAcctNo";
        public const string REBATEACCRUPROFITNO = "RebateAccruProfitNo";
        public const string REBATEACCRUBRNNO = "RebateAccruBrnNo";
        public const string REMANACCRUACCTNO = "RemanAccruAcctNo";
        public const string REMANACCRUPROFITNO = "RemanAccruProfitNo";
        public const string REMANACCRUBRNNO = "RemanAccruBrnNo";

        public const string REALIZATIONACCTNO = "RealizationAcctNo";
        public const string REALIZATIONPROFITNO = "RealizationProfitNo";
        public const string REALIZATIONBRNNO = "RealizationBrnNo";

        public const string GainLossACCTNO = "GainLossAcctNo";
        public const string GainLossPROFITNO = "GainLossProfitNo";
        public const string GainLossBRNNO = "GainLossBrnNo";

        public const string APACHACCTNO = "ApACHAcctNo";
        public const string APACHPROFITNO = "ApACHProfitNo";

        public const string RECSTAMP = "RecStamp";
        private System.Collections.Specialized.NameValueCollection mVarCollection = new System.Collections.Specialized.NameValueCollection();
        public System.Collections.Specialized.NameValueCollection VarCollection
        {
            get { return mVarCollection; }
            set { mVarCollection = value; }
        }

        public MCurrencyDEL()
        {
            //Create mCurrency structure
            CreatemCurrencyStructure();

        }

        //=========mCurrency============================
        private void CreatemCurrencyStructure()
        {
            DataTable table;
            DataColumnCollection DCC;
            DataColumn DC = new DataColumn();
            table = new DataTable(TABLENAME_MCURRENCY);
            DCC = table.Columns;

            DC = new DataColumn(RECID, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(CURNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(CURCODE, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(CURDESC, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(CURRATESELLPRODUCT, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(ReportCurRate, typeof(System.Decimal));
            DCC.Add(DC);

            DC = new DataColumn(CURRATEPURCHPRODUCT, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(ARACCTNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(ARPROFITNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(ARBRNNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(AREXCHACCTNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(AREXCHPROFITNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(AREXCHBRNNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(APACCTNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(APPROFITNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(APBRNNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(APEXCHACCTNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(APEXCHPROFITNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(APEXCHBRNNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(BANKACCTNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(BANKPROFITNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(BANKBRNNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(BANKEXCHACCTNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(BANKEXCHPROFITNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(BANKEXCHBRNNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(ARDISCACCTNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(ARDISCPROFITNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(ARDISCBRNNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(INTERESTACCTNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(INTERESTPROFITNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(INTERESTBRNNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(APDISCACCTNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(APDISCPROFITNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(APDISCBRNNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(LASTCHQNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(ACCRUACCTNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(ACCRUPROFITNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(APBANKACCTNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(APBANKPROFITNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(APBANKBRNNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(LASTRATECHGDATE, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(SETTDISCACCTNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(SETTDISCPROFITNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(SETTDISCBRNNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(ARGSTACCTNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(ARGSTPROFITNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(ARGSTBRNNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(APGSTACCTNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(APGSTPROFITNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(APGSTBRNNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(REBATECRACCTNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(REBATECRPROFITNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(REBATEDRACCTNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(REBATEDRPROFITNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(DEPOSITACCTNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(DEPOSITPROFITNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(DEPOSITBRNNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(OVERSHORTACCTNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(OVERSHORTPROFITNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(OVERSHORTBRNNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(FRTREDTACCTNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(FRTREDTPROFITNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(LASTCHQNO1, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(BRANCHCLEARACCTNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(BRANCHCLEARPROFITNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(BRANCHCLEARBRNNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(INTERCOMPFUNDTRFACCTNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(INTERCOMPFUNDTRFPROFITNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(INTERCOMPFUNDTRFBRANCHNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(INVTRFACCTNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(INVTRFPROFITNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(FREIGHTAPACCTNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(FREIGHTAPPROFITNO, typeof(System.String));
            DC.DefaultValue = "000";
            DCC.Add(DC);

            DC = new DataColumn(FREIGHTAPBRNNO, typeof(System.String));
            DC.DefaultValue = "000";
            DCC.Add(DC);

            DC = new DataColumn(MILLAPACCTNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(MILLAPPROFITNO, typeof(System.String));
            DC.DefaultValue = "000";
            DCC.Add(DC);

            DC = new DataColumn(MILLAPBRNNO, typeof(System.String));
            DC.DefaultValue = "000";
            DCC.Add(DC);

            DC = new DataColumn(MISCAPACCTNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(MISCAPPROFITNO, typeof(System.String));
            DC.DefaultValue = "000";
            DCC.Add(DC);

            DC = new DataColumn(MISCAPBRNNO, typeof(System.String));
            DC.DefaultValue = "000";
            DCC.Add(DC);

            DC = new DataColumn(FREIGHTINACCRUACCTNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(FREIGHTINACCRUPROFITNO, typeof(System.String));
            DC.DefaultValue = "000";
            DCC.Add(DC);

            DC = new DataColumn(FREIGHTINACCRUBRNNO, typeof(System.String));
            DC.DefaultValue = "000";
            DCC.Add(DC);

            DC = new DataColumn(FREIGHTOUTACCRUACCTNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(FREIGHTOUTACCRUPROFITNO, typeof(System.String));
            DC.DefaultValue = "000";
            DCC.Add(DC);

            DC = new DataColumn(FREIGHTOUTACCRUBRNNO, typeof(System.String));
            DC.DefaultValue = "000";
            DCC.Add(DC);

            DC = new DataColumn(HANDINGACCRUACCTNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(HANDINGACCRUPROFITNO, typeof(System.String));
            DC.DefaultValue = "000";
            DCC.Add(DC);

            DC = new DataColumn(HANDINGACCRUBRNNO, typeof(System.String));
            DC.DefaultValue = "000";
            DCC.Add(DC);

            DC = new DataColumn(REBATEACCRUACCTNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(REBATEACCRUPROFITNO, typeof(System.String));
            DC.DefaultValue = "000";
            DCC.Add(DC);

            DC = new DataColumn(REBATEACCRUBRNNO, typeof(System.String));
            DC.DefaultValue = "000";
            DCC.Add(DC);

            DC = new DataColumn(REMANACCRUACCTNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(REMANACCRUPROFITNO, typeof(System.String));
            DC.DefaultValue = "000";
            DCC.Add(DC);

            DC = new DataColumn(REMANACCRUBRNNO, typeof(System.String));
            DC.DefaultValue = "000";
            DCC.Add(DC);

            DC = new DataColumn(RECSTAMP, typeof(System.Byte[]));
            DCC.Add(DC);

            DC = new DataColumn(APACHACCTNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(APACHPROFITNO, typeof(System.String));
            DC.DefaultValue = "000";
            DCC.Add(DC);

            DC = new DataColumn(REALIZATIONACCTNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(REALIZATIONPROFITNO, typeof(System.String));
            DC.DefaultValue = "000";
            DCC.Add(DC);

            DC = new DataColumn(REALIZATIONBRNNO, typeof(System.String));
            DC.DefaultValue = "000";
            DCC.Add(DC);

            DC = new DataColumn(GainLossACCTNO, typeof(System.String));
            DCC.Add(DC);

            DC = new DataColumn(GainLossPROFITNO, typeof(System.String));
            DC.DefaultValue = "000";
            DCC.Add(DC);

            DC = new DataColumn(GainLossBRNNO, typeof(System.String));
            DC.DefaultValue = "000";
            DCC.Add(DC);

            this.Tables.Add(table);
        }

    }
}